Diagram SYS_UserDefinition

Defincja diagramu SYS_UserDefinition

Name

SYS_UserDefinition

Code

SYS_UserDefinition

Comment

 


Lista tabel diagramu

Name

Code

Action

Action

EportalAccountShare

EportalAccountShare

EportalPasswordResetRequest

EportalPasswordResetRequest

EPortalUserDefinition

EPortalUserDefinition

ExportList

ExportList

ExternalOperatorType

ExternalOperatorType

ExternalOperatorTypeText

ExternalOperatorTypeText

ExternalUserDefinition

ExternalUserDefinition

LEportalUserMessage

LEportalUserMessage

LOrgUnitUserGroup

LOrgUnitUserGroup

LSystemUserGroup

LSystemUserGroup

LUserDefinitionPhSt

LUserDefinitionPhSt

LUserGroup

LUserGroup

LUserGroupSysFct

LUserGroupSysFct

LUserMessage

LUserMessage

LUserOrgUnit

LUserOrgUnit

LUserSysFct

LUserSysFct

LUserType

LUserType

LUserTypeSysMgr

LUserTypeSysMgr

LWorkStationMessage

LWorkStationMessage

Message

Message

OrgUnitAccess

OrgUnitAccess

OrgUnitAccessText

OrgUnitAccessText

PasswordHist

PasswordHist

Person

Person

Personnel

Personnel

PersonnelType

PersonnelType

PhLStOrgUnitCon

PhLStOrgUnitCon

PhLStOrgUnitConType

PhLStOrgUnitConType

PhLStOrgUnitConTypeText

PhLStOrgUnitConTypeText

PhLStUserDefinition

PhLStUserDefinition

PhSt

PhSt

PhStOrgUnit

PhStOrgUnit

SelfControlNormRestriction

SelfControlNormRestriction

SysFct

SysFct

System

System

TimeStampLock

TimeStampLock

UserDefinition

UserDefinition

UserGroup

UserGroup

UserProfile

UserProfile

UserSign

UserSign

UserSignFile

UserSignFile

UserSignType

UserSignType

UserSignTypeText

UserSignTypeText

UserToUserPermission

UserToUserPermission

UserType

UserType

WaitingList

WaitingList

WaitingListXMLChangeLog

WaitingListXMLChangeLog


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

I_1

I_1

Person

UserDefinition

PersonID

 

 

R_19

R_19

UserGroup

LUserGroupSysFct

UserGroupID

 

 

R_20

R_20

SysFct

LUserGroupSysFct

SysFctID

 

 

R_352

R_352

UserDefinition

LUserType

PersonID

 

 

R_353

R_353

UserType

LUserType

UserTypeID

 

 

R_354

R_354

UserDefinition

LUserGroup

PersonID

 

 

R_355

R_355

UserGroup

LUserGroup

UserGroupID

 

 

R_356

R_356

UserDefinition

LUserSysFct

PersonID

 

 

R_357

R_357

SysFct

LUserSysFct

SysFctID

 

 

R_358

R_358

UserType

LUserTypeSysMgr

UserTypeID

 

 

R_359

R_359

SysFct

LUserTypeSysMgr

SysFctID

 

 

R_373

R_373

UserGroup

LOrgUnitUserGroup

UserGroupID

 

 

R_1189

R_1189

UserDefinition

LUserOrgUnit

PersonID

 

 

R_1552

R_1552

Person

TimeStampLock

PersonID

 

 

R_1559

R_1559

UserGroup

LSystemUserGroup

UserGroupID

 

 

R_1560

R_1560

System

LSystemUserGroup

SystemID

 

 

R_2002

R_2002

Message

LUserMessage

MessageID

 

 

R_2082

R_2082

UserDefinition

System

PersonID

 

 

R_2875

R_2875

OrgUnitAccess

LUserTypeSysMgr

OrgUnitAccessID

 

 

R_3070

R_3070

Message

LWorkStationMessage

MessageID

 

 

R_8270

R_8270

OrgUnitAccess

OrgUnitAccessText

OrgUnitAccessID

 

 

R_8271

R_8271

OrgUnitAccess

LOrgUnitUserGroup

OrgUnitAccessID

 

 

R_8272

R_8272

OrgUnitAccess

LUserOrgUnit

OrgUnitAccessID

 

 

R_8273

R_8273

OrgUnitAccess

LUserSysFct

OrgUnitAccessID

 

 

R_8274

R_8274

OrgUnitAccess

LUserGroupSysFct

OrgUnitAccessID

 

 

R_8770

R_8770

UserDefinition

LUserDefinitionPhSt

PersonID

 

 

R_8771

R_8771

PhSt

LUserDefinitionPhSt

StID

 

 

R_8832

R_8832

Person

EPortalUserDefinition

PersonID

 

 

R_8891

R_8891

System

ExternalUserDefinition

SystemID

 

 

R_8892

R_8892

UserDefinition

ExternalUserDefinition

PersonID

 

 

R_8893

R_8893

ExternalOperatorType

ExternalUserDefinition

ExternalOperatorTypeID

 

 

R_8894

R_8894

ExternalOperatorType

ExternalOperatorTypeText

ExternalOperatorTypeID

 

 

R_8895

R_8895

System

ExternalOperatorType

SystemID

 

 

R_8957

R_8957

PhSt

PhStOrgUnit

StID

 

 

R_9031

R_9031

Person

LEportalUserMessage

PersonID

 

 

R_9032

R_9032

Message

LEportalUserMessage

MessageID

 

 

R_9033

R_9033

Message

LEportalUserMessage

ReMessageId

 

 

R_9080

R_9080

UserDefinition

UserToUserPermission

UserID

 

 

R_9081

R_9081

SysFct

UserToUserPermission

SysFctID

 

 

R_9083

R_9083

Personnel

UserToUserPermission

PersonID

 

 

R_9084

R_9084

PersonnelType

UserToUserPermission

PersonnelTypeID

 

 

R_9252

R_9252

SysFct

ExportList

SysFctID

 

 

R_9253

R_9253

Person

ExportList

PersonID

 

 

R_9254

R_9254

ExportList

WaitingListXMLChangeLog

ExportListID

 

 

R_9255

R_9255

WaitingList

WaitingListXMLChangeLog

WaitingListID

 

 

R_9347

R_9347

Person

EportalAccountShare

PersonID

 

 

R_9458

R_9458

UserDefinition

PasswordHist

PersonID

 

 

R_9782

R_9782

Person

PhLStUserDefinition

PersonID

 

 

R_10111

R_10111

PhSt

PhLStOrgUnitCon

StID

 

 

R_10112

R_10112

PhLStOrgUnitConType

PhLStOrgUnitConTypeText

LStOrgUnitConTypeID

 

 


2